package com.example.javaairportflightanalysis.dao;

import com.example.javaairportflightanalysis.dao.sql.DfdlSqlProvider;
import com.example.javaairportflightanalysis.dao.sql.DfmeBllsSqlProvider;
import com.example.javaairportflightanalysis.domin.dto.DfmeBllsDto;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;

import java.util.List;

/**
 * @author shen
 */
public interface DfmeBllsMapper {
    /**
     * 查询行李的情况
     */
    @Select("SELECT vmdb.ddtm,vmdb.fide,vmdb.btno,vmdb.code,vmdb.estr,vmdb.eend,vmdb.rstr,vmdb.rend \n" +
            "FROM zbtj.VW_META_DFME_BLLS vmdb;")
    List<DfmeBllsDto> getLuggage();

    /**
     * 搜索行李情况
     */
    @SelectProvider(value = DfmeBllsSqlProvider.class ,method = "selectLuggage")
    List<DfmeBllsDto> selectLuggage(String fide,String ddtm,String code);
}
